package com.jz.beijianbao.subclass.mapper;

import com.jz.beijianbao.subclass.bean.SubClass;
import com.jz.beijianbao.subclass.bean.SubClassAdd;
import com.jz.beijianbao.subclass.bean.SubClassSelectVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SubMapper {

    List<SubClass> queryPag(SubClassSelectVo subClassSelectVo);

    int add(SubClass subClass);

    SubClass selectById(Integer id);

    int update(SubClassAdd subClassAdd);

    int status(SubClass subClass);

    int queryCount(SubClassSelectVo subClassSelectVo);

    @Select("select * from subclass where code= #{code}")
    SubClassAdd queryByCode(String code);
    @Select("select * from subclass where name= #{name}")
    SubClassAdd queryByName(String name);
}
